Steps to create the Industry KPI Tiles 9
a. Open a new sheet and Rename the Title "Total Tickets".
b. Click on analysis
b. Click on Create calculated field
c. Change the Calculated field name to Total Tickets
d. Double click COUNTD from the function list and type Ticket ID inside the parenthesis ...example: COUNTD(Ticket ID) and Click OK.
e. Drag and drop Total Tickets on the Text card.
2. Format the Text and Background Color for Title
a. Right Click the Title and click Format Title
b. Click Shading
c. Click More Colors
d. Change Color Values Red: 59, Green: 130, Blue: 149
e. Click OK
f. Right Click on Title again, this time Select Edit Title.
g. Highlight the text Total Tickets and Change Font to Tableau Bold.
h. Click the drop-down arrow next to black color Box and select White color.
i. Click on Center Alignment and OK.
3. Format the Text and Background Color for Data Pane
a. Right Click the Data Pane and click Format
b. Click on A for formatting if it hasn't been selected by default.
c. Click the Drop down arrow next to Pane and Select Tableau Bold.
d. Change Text size to 22 and color to white.
e. Click on Alignment and align Center.
f. Click on Color Fill Jar
g. Click on Drop down arrow on Pane and Click More Colors
h. Change Color Values Red: 62, Green: 148, Blue: 172 and Click OK.
3. Avg. First Contact Resolution Rate (Key Performance Indicator)
a. Drag and drop First Contact Resolution Rate on the Text card.
b. Right click on
[SUM (First Contact Resolution Rate)]
c. Then click Measure (Sum) and then
d. Click Average.
e. Right click on [Avg (First Contact Resolution Rate)]
f. Click on Format.
g. Select Numbers
h. Click percentage
4. For Formatting text and coloring background Please repeat the steps 2 and 3.
Repeat the same process to create Avg.1st Rsp Hrs but this time drag and drop First Response Hours column. It should look like the picture below:
Repeat the same process to create Time to close days but this time drag and drop Time to close days column on the text card. It should look like the picture below:
a. Open a new sheet and Rename the Title "Total Tickets".
b. Click on analysis
b. Click on Create calculated field
c. Change the Calculated field name to Total Tickets
d. Double click COUNTD from the function list and type Ticket ID inside the parenthesis ...example: COUNTD(Ticket ID) and Click OK.
e. Drag and drop Total Tickets on the Text card.
2. Format the Text and Background Color for Title
a. Right Click the Title and click Format Title
b. Click Shading
c. Click More Colors
d. Change Color Values Red: 59, Green: 130, Blue: 149
e. Click OK
f. Right Click on Title again, this time Select Edit Title.
g. Highlight the text Total Tickets and Change Font to Tableau Bold.
h. Click the drop-down arrow next to black color Box and select White color.
i. Click on Center Alignment and OK.
3. Format the Text and Background Color for Data Pane
a. Right Click the Data Pane and click Format
b. Click on A for formatting if it hasn't been selected by default.
c. Click the Drop down arrow next to Pane and Select Tableau Bold.
d. Change Text size to 22 and color to white.
e. Click on Alignment and align Center.
f. Click on Color Fill Jar
g. Click on Drop down arrow on Pane and Click More Colors
h. Change Color Values Red: 62, Green: 148, Blue: 172 and Click OK.
3. Avg. First Contact Resolution Rate (Key Performance Indicator)
a. Drag and drop First Contact Resolution Rate on the Text card.
b. Right click on
[SUM (First Contact Resolution Rate)]
c. Then click Measure (Sum) and then
d. Click Average.
e. Right click on [Avg (First Contact Resolution Rate)]
f. Click on Format.
g. Select Numbers
h. Click percentage
4. For Formatting text and coloring background Please repeat the steps 2 and 3.
Repeat the same process to create Avg.1st Rsp Hrs but this time drag and drop First Response Hours column. It should look like the picture below:
Repeat the same process to create Time to close days but this time drag and drop Time to close days column on the text card. It should look like the picture below: